﻿/****************************************************************************************************
 **        Name: Severity
 ** Description: Lookup table of the different severities of exceptions.
 ****************************************************************************************************
 ** Revisions
 **  Date        Author               Work Item  Description
 **  ----------  -------------------  ---------  ----------------------------------------------------
 **  11/30/2008  Chad Green             11774    Initial Development
 ****************************************************************************************************/

CREATE TABLE dbo.Severity
(
	ID smallInt NOT NULL,
	Description varChar(50) NOT NULL,
	SortOrder   smallInt    NOT NULL,
	IsActive    bit         NOT NULL
)
GO

EXEC sp_addextendedproperty N'MS_Description', N'Lookup table of the different severities of exceptions.', 'SCHEMA', N'dbo', 'TABLE', N'Severity', NULL, NULL
GO
EXEC sp_addextendedproperty N'MS_Description', N'Identifier of the severity.', 'SCHEMA', N'dbo', 'TABLE', N'Severity', 'COLUMN', N'ID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Description of the severity.', 'SCHEMA', N'dbo', 'TABLE', N'Severity', 'COLUMN', N'Description'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The sorting order of the severity record.', 'SCHEMA', N'dbo', 'TABLE', N'Severity', 'COLUMN', N'SortOrder'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Flag indicating whether the lookup value is active.', 'SCHEMA', N'dbo', 'TABLE', N'Severity', 'COLUMN', N'IsActive'
GO